package ref;

import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.List;

import org.apache.log4j.Logger;

import util.UsualUtil;
import util.XxlsData;

public class GuangZhouJunQu implements XxlsData {
	private static Logger log = Logger.getLogger("GuangZhouJunQu");
	public void dataType(PreparedStatement ps, List<String> rowlist) {
		try {
			for (int j = 0; j < rowlist.size(); j++) {
	        	switch (j) {
				case 0:
					ps.setInt(1,Integer.valueOf(rowlist.get(0).trim()));break;//seq
				case 1:
					ps.setString(2, rowlist.get(1).trim());break;//month_id
				case 2:
					ps.setString(3, rowlist.get(2).trim());break;//医院
				case 3:
					ps.setString(4, rowlist.get(3).trim());break;//product_name
				case 4:
					ps.setString(5, rowlist.get(4).trim());break;//mode
				case 5:
					ps.setString(6, rowlist.get(5).trim());break;//medical_spec
				case 6:
					ps.setString(7, rowlist.get(6).trim());break;//medical_spec
				case 7:
					ps.setString(8, rowlist.get(7).trim());break;//medical_spec
				case 8:
					ps.setString(9, rowlist.get(8).trim());break;//org_name
				case 9:
					ps.setString(10, rowlist.get(9).trim());break;//org_name
				case 10:
					ps.setString(11, rowlist.get(10).trim());break;//gift
				case 11:
					ps.setString(12, rowlist.get(11).trim());break;//
				case 12:
					ps.setString(13, rowlist.get(12).trim());break;//
				case 13:
					ps.setFloat(14, Float.valueOf(rowlist.get(13).trim()));break;//
				case 14:
					ps.setInt(15, Integer.valueOf(rowlist.get(14).trim()));break;//mode
				case 15:
					ps.setFloat(16, Float.valueOf(rowlist.get(15).trim()));break;//medical_spec
				case 16:
					ps.setFloat(17, Float.valueOf(rowlist.get(16).trim()));break;//medical_spec
				default:
					log.info(System.err);
				}
			}
		} catch (NumberFormatException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
}